'salesAna3.0.sam.sht
'AmiSoft!                   
@TODAY
' *Sales Analysis*
^Cost of 
^Fixed
^Total
^Store
^Code
^Sales
'Goods sold
^Expenses
^Expenses
^Profit
	'Wichita
+D6+E6
+C6-F6
'Kansas City
+D7+E7
+C7-F7
'Denver
+D8+E8
+C8-F8
'Dallas
+D9+E9
+C9-F9
'total
@SUM(C6..C9)
@SUM(D6..D9)
@SUM(E6..E9)
@SUM(F6..F9)
@SUM(G6..G9)
'=============
'=============
'=============
'=============
'=============
'=============
'=============
$'Income projection for sales change
	'Wichita
+C6*(1+$E$13)
H+D6*(1+$E$13)
+D15+E15
3334+C15-F15
'Kansas City
{+C7*(1+$E$13)
+D7*(1+$E$13)
{+D16+E16
+C16-F16
'Denver
+C8*(1+$E$13)
G[3334+D8*(1+$E$13)
+D17+E17
\(+C17-F17
'Dallas
+C9*(1+$E$13)
\*+D9*(1+$E$13)
+D18+E18
+C18-F18
'Total
@SUM(C18..C15)
]@SUM(D18..D15)
@SUM(E15..E18)
]@SUM(F15..F18)
\*@SUM(G15..G18)